﻿//===============================================================================
// TREASURY MANAGMENT INFORMATION SYSTEMS 
// Clients Directory DATA LAYER
//===============================================================================
// Copyright © FINA. 2008
//===============================================================================

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using DAL.ds.dsCitiesTableAdapters;
using DAL.ds.dsContractsTableAdapters;


namespace DAL
{
   public class Clients
    {

        public DataSet dsCities(int codeID)
        {
          
            string conn  =   DAL.Properties.Settings.Default.dsConnString;

            ds.dsCitiesTableAdapters.dtCityTableAdapter tb = new dtCityTableAdapter();
            

            /// <summary>
            /// Load Clients Directory 
            /// </summary>
            /// <returns>Dataset</returns>
            /// <remarks> </remarks>


            
            // connString = new GetConnectionString();

            
            /*
            SqlConnection conn = new SqlConnection(connString.connString());
            SqlCommand cmd = new SqlCommand("speGet_dtCity", conn);

            cmd.Parameters.Add("@CodeID", SqlDbType.Int).Value = codeID;

            cmd.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter myAdapter = new SqlDataAdapter(cmd);

            DataSet dsCities = new DataSet();
            myAdapter.Fill(dsCities, "dsCities");

            conn.Close();

            return dsCities;
             * 
             */
            return null;
        }

    }


        
       

}
